don't click here

TSC moved


    Print

Author Topic: TSC moved  (Read 34484 times)

0 Members and 5 Guests are viewing this topic.

Offline Rolken

TSC moved
« on: December 02, 2006, 06:32:08 pm »
We're up on DreamHost now. Unfortunately, things are moving rather slower; I'll see what I can do about it. Submissions are down in the meantime. F-Zero will come up as soon as the subdomain passes through.

Update: Here's the deal with submissions - they simply aren't efficient enough to deal with the slowness of the database server. I did a partial rewrite and tested a few days ago (hence the new stats in the update list), and they're getting closer, but aren't quite all there yet; it takes roughly 5sec to process each stat submitted, which is fine for a single submission but when someone submits a sheet of 50 just doesn't cut it. So I'm doing a more thorough rewrite which does more extensive webserver-side caching, and that should bring us through. Optimistic TTL 1-2 days, pessimistic a week, cynical 2-3 weeks.

Another random note - if you pay attention to the processing time at the bottom, you'll see it occasionally dips below zero. I have no idea why, and it's not just TSC; even the server db apps give negative processing times. Huh.

Update2: They've moved us onto an apparently less loaded server. Hopefully that'll get TSC up to speed.

Update3: Well, submissions were about to go up, and then the server randomly asploded and Gerbil and I spent the next few hours picking up the pieces. I guess we'll see how things go in the morning, since it looks like there's a kink or two left to iron out, but the speed's finally there.

Update4: TSC is re-re-moving, to a server that can deal with the load. Any posts made on the forum after this point will -not- carry over, so you probably don't want to bother posting until this message is no longer on the front page.
« Last Edit: December 23, 2006, 10:15:25 pm by Rolken »
StH JJ1 WkS+ Sal++^i Rbk++i Knu- McS+++ P++ D[af]opw $++++ E03 A24 GM CoUT
What fun is it being cool if you can't wear a sombrero?

Offline Groudon

  • 1 hour, 39 minutes, 52 seconds
  • Broseidon
  • TSC: Groudon199
  • win10 firefox
  • Posts: 1504
    • View Profile
    • My YouTube channel
Re: TSC moved
« Reply #1 on: December 02, 2006, 06:33:51 pm »
Hey, at least the site's back up.

Offline Taco

  • If I had a (ban)hammer
  • TSC: NintenDan
  • win10 chrome
  • Posts: 821
    • View Profile
    • http://www.freewebs.com/nintendan
Re: TSC moved
« Reply #2 on: December 02, 2006, 06:40:55 pm »
yay

Offline Thorn

  • wroar
  • Architect emeritus
  • TSC Profile
  • win10 chrome
  • Posts: 1309
  • Former admin, lucid dreamer, lover of burgers
    • View Profile
Re: TSC moved
« Reply #3 on: December 02, 2006, 06:44:02 pm »
<RPGnutter> Well I think your reasoning was dumb, so you get sassed
<RPGnutter> Thats how it works

Offline magnum12

  • Awesome Overlord of TMMC
  • Broseidon
  • TSC Profile
  • winvista msie9
  • Posts: 1184
    • View Profile
Re: TSC moved
« Reply #4 on: December 02, 2006, 06:51:45 pm »
Good to be back. While we're waiting for submissions to come back, I'll start getting those S ranks on Sonic 06 and start some TAing. Just short of sub 3 minutes for Radical Train (Sonic), short of 4 minutes on Wave Ocean (Sonic), got sub 3 for Radical Train (Shadow), sub 3 for Tropical Jungle (Silver), and sub 10 for Crisis City (Silver).
Ever know what its like to get pwned by a book? Sonic certainly does.

Offline KnucklesSonic8

Re: TSC moved
« Reply #5 on: December 02, 2006, 07:17:50 pm »
Yeah really, Groudon. I'm happy too. I got a lot of stuff to do here now that the site's back up. I got a good feeling about Riders and plus got a MAJOR update for my Compt. Suggestions topic - magnum, I'm sure you'd be interested since it also covers 06.
Wiiloveit

Current Competition Focus: ---
Wants S&S All-Stars Racing

Re: TSC moved
« Reply #6 on: December 02, 2006, 09:12:48 pm »
The site's back up. Huzzah! :)
Never forget who you are.
DeviantART account: (link)

Offline maggot

  • If I had a (ban)hammer
  • TSC Profile
  • win10 chrome
  • Posts: 169
  • old-school 2D pwnage
    • View Profile
Re: TSC moved
« Reply #7 on: December 02, 2006, 09:17:46 pm »
So good to see that the site is back :)
you can run, but not fast enough...

Offline maggot

  • If I had a (ban)hammer
  • TSC Profile
  • win10 chrome
  • Posts: 169
  • old-school 2D pwnage
    • View Profile
Re: TSC moved
« Reply #8 on: December 02, 2006, 09:20:02 pm »
By the way... what heppened to the site?
you can run, but not fast enough...

Offline Crowbar

Re: TSC moved
« Reply #9 on: December 02, 2006, 09:20:13 pm »
Doesn't seem slow to me. :O

Glad to see it everything back at last.

Offline JBertolli

Re: TSC moved
« Reply #10 on: December 03, 2006, 12:49:49 am »
I'm glad but really can't wait for submissions to be allowed again. At the same time, I started getting very good Sonic Heroes times and the site was down. I also didn't even know the f-zero site went up yet until the site was being moved. Hope I can submit tomorrow ^_^

Offline GerbilSoft

  • Architect of the Matrix
  • TSC Profile
  • linux firefox
  • Posts: 719
  • RickRotate'd.
    • View Profile
Re: TSC moved
« Reply #11 on: December 03, 2006, 04:04:18 am »
It seems that right now, most of the slowdown is caused by the database server. The SQL queries need to be optimized so it doesn't take a bazillion queries to update a single stat. :)

Also, I helped Rolken set up eAccelerator, a PHP cache, so the PHP scripts should execute more quickly (disregarding the SQL server lag).

Offline X-5

Re: TSC moved
« Reply #12 on: December 06, 2006, 04:31:11 pm »
how come i'm seeing new stats pop up, but i'm still unable to submit any of my own? is there a secret way to hack the submissions page i'm unaware of?

Offline Groudon

  • 1 hour, 39 minutes, 52 seconds
  • Broseidon
  • TSC: Groudon199
  • win10 firefox
  • Posts: 1504
    • View Profile
    • My YouTube channel
Re: TSC moved
« Reply #13 on: December 06, 2006, 04:36:23 pm »
Rolken was testing submissions.  If you were in the chat, you'd know.

* Groudon shot

Offline KnucklesSonic8

Re: TSC moved
« Reply #14 on: December 06, 2006, 05:00:04 pm »
I'm glad but really can't wait for submissions to be allowed again. At the same time, I started getting very good Sonic Heroes times and the site was down. I also didn't even know the f-zero site went up yet until the site was being moved. Hope I can submit tomorrow ^_^

Yeah really! I have literal records to submit for Riders that I'm dying to submit!! :( (Plus one stats for Heroes but that's not as noteworthy.)

I hope I can submit soon as well but props goes out to all of you who've been working behind the scenes on making sure the site is running properly, especially with the server change and all.
Wiiloveit

Current Competition Focus: ---
Wants S&S All-Stars Racing

Offline KnucklesSonic8

Re: TSC moved
« Reply #15 on: December 16, 2006, 08:49:46 am »
Rolken, I think your "cynical" comment should be replaced by "realistic". :P
Wiiloveit

Current Competition Focus: ---
Wants S&S All-Stars Racing

Offline sonicandamy

  • The Orginal DsS
  • TSC Profile
  • win10 chrome
  • Posts: 260
  • ^ sonicandamy-your lovable sonic rush boss leader
    • View Profile
Re: TSC moved
« Reply #16 on: December 17, 2006, 09:10:18 am »
well since we are moving up into the forth week can we have a new name after cynical?
Megabyte-sized sigs can get off the internet.
-Rolken

Offline X-5

Re: TSC moved
« Reply #17 on: December 17, 2006, 09:56:37 am »
uh, it's only been like a week max since he posted that, where'd you get 4 weeks from? Oh and btw rolken, I guess no one has noticed this yet, but ever since tsc came back the "anti-records" page has been broken,

Offline Groudon

  • 1 hour, 39 minutes, 52 seconds
  • Broseidon
  • TSC: Groudon199
  • win10 firefox
  • Posts: 1504
    • View Profile
    • My YouTube channel
Re: TSC moved
« Reply #18 on: December 17, 2006, 11:54:20 am »
I think he got the 4 weeks from the time without submissions, since s&a has become impatient to submit his Rush stats.

Offline KnucklesSonic8

Re: TSC moved
« Reply #19 on: December 17, 2006, 01:45:21 pm »
I think he got the 4 weeks from the time without submissions, since s&a has become impatient to submit his Rush stats.

As am I and everyone else around here I guess.

Oh and Antirecords aren't broken for me but then again I haven't check recently.
Wiiloveit

Current Competition Focus: ---
Wants S&S All-Stars Racing

Offline sonicandamy

  • The Orginal DsS
  • TSC Profile
  • win10 chrome
  • Posts: 260
  • ^ sonicandamy-your lovable sonic rush boss leader
    • View Profile
Re: TSC moved
« Reply #20 on: December 17, 2006, 02:41:24 pm »
i said i'd wait till christmas but then im outa here. (rolken will not purposly not put up submissions until after christmas becasue of that :)  )  lol...
Megabyte-sized sigs can get off the internet.
-Rolken

Offline Bilan

  • Broseidon
  • TSC: RPGnutter
  • win10 chrome
  • Posts: 3883
  • ZURA ZURA CHUUPA CHUUPA CHUU CHUU
    • View Profile
    • I'm suffering help me Garian
Re: TSC moved
« Reply #21 on: December 17, 2006, 03:30:45 pm »
I think he got the 4 weeks from the time without submissions, since s&a has become impatient to submit his Rush stats.

As am I and everyone else around here I guess.

Im not getting impatient to submit anything.
Did you not think I had a mind?

Offline sonicandamy

  • The Orginal DsS
  • TSC Profile
  • win10 chrome
  • Posts: 260
  • ^ sonicandamy-your lovable sonic rush boss leader
    • View Profile
Re: TSC moved
« Reply #22 on: December 17, 2006, 05:06:03 pm »
I think he got the 4 weeks from the time without submissions, since s&a has become impatient to submit his Rush stats.

As am I and everyone else around here I guess.

Im not getting impatient to submit anything.


>.< Says people who only got crap to submit.
Megabyte-sized sigs can get off the internet.
-Rolken

Offline Groudon

  • 1 hour, 39 minutes, 52 seconds
  • Broseidon
  • TSC: Groudon199
  • win10 firefox
  • Posts: 1504
    • View Profile
    • My YouTube channel
Re: TSC moved
« Reply #23 on: December 17, 2006, 05:07:28 pm »
I think he got the 4 weeks from the time without submissions, since s&a has become impatient to submit his Rush stats.

As am I and everyone else around here I guess.

Im not getting impatient to submit anything.


>.< Says people who only got crap to submit.
If by "crap" you mean insane stat improvements, then yes.

Offline sonicandamy

  • The Orginal DsS
  • TSC Profile
  • win10 chrome
  • Posts: 260
  • ^ sonicandamy-your lovable sonic rush boss leader
    • View Profile
Re: TSC moved
« Reply #24 on: December 17, 2006, 05:19:59 pm »
I think he got the 4 weeks from the time without submissions, since s&a has become impatient to submit his Rush stats.

As am I and everyone else around here I guess.

Im not getting impatient to submit anything.


>.< Says people who only got crap to submit.
If by "crap" you mean insane stat improvements, then yes.


-.- not chew

(...to many quotes...)
Megabyte-sized sigs can get off the internet.
-Rolken

Offline Groudon

  • 1 hour, 39 minutes, 52 seconds
  • Broseidon
  • TSC: Groudon199
  • win10 firefox
  • Posts: 1504
    • View Profile
    • My YouTube channel
Re: TSC moved
« Reply #25 on: December 17, 2006, 05:25:34 pm »
I think he got the 4 weeks from the time without submissions, since s&a has become impatient to submit his Rush stats.

As am I and everyone else around here I guess.

Im not getting impatient to submit anything.


>.< Says people who only got crap to submit.
If by "crap" you mean insane stat improvements, then yes.


-.- not chew

(...to many quotes...)
You don't think I have any insane stat improvements?  Think again.  My current best is around 2:50, giving me a 7-spot jump from orange to red.

Offline Bilan

  • Broseidon
  • TSC: RPGnutter
  • win10 chrome
  • Posts: 3883
  • ZURA ZURA CHUUPA CHUUPA CHUU CHUU
    • View Profile
    • I'm suffering help me Garian
Re: TSC moved
« Reply #26 on: December 17, 2006, 06:18:49 pm »
Well if a 5th place time is now crap, then yes, crap to submit.
Did you not think I had a mind?

Offline sonicandamy

  • The Orginal DsS
  • TSC Profile
  • win10 chrome
  • Posts: 260
  • ^ sonicandamy-your lovable sonic rush boss leader
    • View Profile
Re: TSC moved
« Reply #27 on: December 18, 2006, 01:57:30 am »
GOURDEN I SAID "not chew=not you"
Megabyte-sized sigs can get off the internet.
-Rolken

Offline Bilan

  • Broseidon
  • TSC: RPGnutter
  • win10 chrome
  • Posts: 3883
  • ZURA ZURA CHUUPA CHUUPA CHUU CHUU
    • View Profile
    • I'm suffering help me Garian
Re: TSC moved
« Reply #28 on: December 18, 2006, 07:03:48 am »
You didnt specify in a term those of us that dont speak "ghetto" would understand.
Did you not think I had a mind?

Offline sonicandamy

  • The Orginal DsS
  • TSC Profile
  • win10 chrome
  • Posts: 260
  • ^ sonicandamy-your lovable sonic rush boss leader
    • View Profile
Re: TSC moved
« Reply #29 on: December 18, 2006, 01:56:27 pm »
sorry
Megabyte-sized sigs can get off the internet.
-Rolken

    Print
 


-- Back to Normal Skin --
Hits: 93 | Hits This Month: 2 | DB Calls: 5 | Mem Usage: 1.33 MB | Time: 0.07s | Printable

The Sonic Center v3.9
Copyright 2003-2011 by The Sonic Center Team.